include 'connessione.php'; $pagina = 'interna'; $titolop = 'Non ci sono elementi in questa sezione'; if(isset($_GET['id_sez']) && $_GET['id_sez']!=''){ $id_sez = $_GET['id_sez']; }else{ $id_sez = 1; } $querysez="SELECT id, titolo FROM traduzioni WHERE tabella='sezioni' AND lingua='it' AND id=$id_sez"; $resultsez=mysql_query($querysez,$link); $rigasez=mysql_fetch_array($resultsez); $titolo = $rigasez['titolo']; if(isset($_GET['id_pag']) && $_GET['id_pag']!=''){ $id_pag = $_GET['id_pag']; }else{ $querypa = "SELECT * FROM pagine WHERE id_sez=$id_sez AND visibile=1 ORDER BY ordine"; $resultpa = mysql_query($querypa,$link); $rigapa = mysql_fetch_array($resultpa); $id_pag = $rigapa['id_pag']; } if($id_pag!=''){ $querypai = "SELECT img FROM pagine WHERE id_pag=$id_pag"; $resultpai = mysql_query($querypai,$link); $rigapai = mysql_fetch_array($resultpai); $imgp = $rigapai['img']; $querytp="SELECT * FROM traduzioni WHERE tabella='pagine' AND id=$id_pag AND lingua='$lingua'"; $resulttp=mysql_query($querytp,$link); $tot_restp = mysql_num_rows($resulttp); $rigatp=mysql_fetch_array($resulttp); if($rigatp['titolo']!=''){ $titolop = $rigatp['titolo']; $testop = $rigatp['testo']; $allegatop = $rigatp['allegato']; } } $queryep= "SELECT * FROM pagine WHERE visibile=1 AND id_sez=$id_sez ORDER BY ordine"; $resultep= mysql_query($queryep,$link); $tot_resep = mysql_num_rows($resultep); if(isset($_GET['id_sotto']) && $_GET['id_sotto']!=''){ $id_sotto = $_GET['id_sotto']; $querysc="SELECT * FROM sottocat WHERE id_sottocat=$id_sotto"; $resultsc=mysql_query($querysc,$link); $rigasc=mysql_fetch_array($resultsc); $querysct="SELECT * FROM traduzioni WHERE tabella='sottocat' AND id=$id_sotto AND lingua='$lingua'"; $resultsct=mysql_query($querysct,$link); $rigasct=mysql_fetch_array($resultsct); $titolosc = $rigasct['titolo']; $sottotitsc = $rigasct['sommario']; } if(isset($_GET['id_prod']) && $_GET['id_prod']!=''){ $id_prod = $_GET['id_prod']; $queryprd="SELECT * FROM prodotti WHERE id_prod=$id_prod"; $resultprd=mysql_query($queryprd,$link); $rigaprd=mysql_fetch_array($resultprd); $queryprdt="SELECT * FROM traduzioni WHERE tabella='prodotti' AND id=$id_prod AND lingua='$lingua'"; $resultprdt=mysql_query($queryprdt,$link); $rigaprdt=mysql_fetch_array($resultprdt); $codiceprod = $rigaprd['codice']; } include 'header.php'; ?>